package com.example.demo.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.beans.IntrospectionException;


@Data
@NoArgsConstructor
@AllArgsConstructor
public class Denglurizhi {
	  private Integer id;
	    private Integer denglurenid;
	    private String denglushijian;
	    private Integer sex;

		private String denglurenname;
		/*private String Sexname;*/

	   public static String[] sexs= {"未指定","男性","女性"};
	   public String getSexname() {
		   if(sex == null)
			   return sexs[0];
	     	return sexs[sex];
	   }
/*
	SELECT denglurizhi.* ,user.name denglurenname from denglurizhi inner join user on  denglurizhi.denglurenid=user.id  where denglurenname like '%admin%'   limit 0,10
	SELECT Yunshugongju.* ,zhigong.name zhigongname FROM Yunshugongju inner join zhigong on Yunshugongju.zhigongid = zhigong.id where chepaihao like '%12345%' limit 0,10
*/



}